"""
:create time: 2020/1/18 16:11 
:author: may
:desc: 
"""
import pandas as pd


def read_excel(filepath):
    """
    读取excel并返回list

    :param filepath: 文件路径
    :type filepath: str
    :return: excel内容
    :rtype: list
    """
    df = pd.read_excel(filepath)
    datas = df.values.tolist()

    for data in datas:
        # 转str并排序
        for i in range(len(data)):
            data[i] = str(data[i])
        data.sort()
    return datas
